package com.chinasoft.movies.mapper;

import com.chinasoft.movies.pojo.GenreRankInVote;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface GenreRankInVoteMapper {

    @Select("select genre,avg_vote from genre_top order by avg_vote desc limit 10")
    List<GenreRankInVote> queryGenreRankInVote();

}
